package com.example.demo6.model;

import java.sql.*;

public class DBTest {

   public String name;
   public  String pass;
   public void sendInfo(String username,String password){
        this.name=username;
        this.pass=password;
    }

    public String userLogin() {
        // 1. 数据库连接信息 (URL, 用户名, 密码)
        String url = "jdbc:mysql://localhost:3306/library_management?useSSL=false&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true";
        String username = "root"; // 你的数据库用户名
        String password = "hu050730"; // 你的数据库密码
        String sql = "select * from user where username= ? and password= ? ";
        String nameChecked=null;

        Connection conn=null;
        PreparedStatement prep=null;
        ResultSet rs=null;
//        int id=0;
//        String email=null;
//        String name="admin";
//        String pass="admin123";
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
            conn  = DriverManager.getConnection(url, username, password);
            prep = conn.prepareStatement(sql);
            prep.setString(1,name);
            prep.setString(2,pass);

            //数据结果集
            rs = prep.executeQuery();
//            while (rs.next()) {
//                 id = rs.getInt(1);
//                 email = rs.getString(6);
//            }
           while (rs.next()){
            nameChecked = rs.getString("name");
           }
           if(nameChecked!=null){
               return nameChecked;
           }else {
               return null;
           }

        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        finally {
            try {
                rs.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
            try {
                prep.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
            try {
                conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
//        System.out.println(id);
//        System.out.println(email);
        return null;
    }
}